package com.oceanread.cn.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.oceanread.cn.entity.Pipeline;
import com.oceanread.cn.entity.Profile;
import com.oceanread.cn.entity.Projections;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface ProfileMapper extends BaseMapper<Profile> {
    List<Profile> getall();

    Integer getnum();

    Integer getnumquery(@Param("key") String key, @Param("value") String value);

    List<Profile> findall(@Param("start") int start, @Param("end") int end);

    List<Profile> query(@Param("start") int start, @Param("end") int end, @Param("key") String key, @Param("value") String value);
    List<Profile> queryNopage(@Param("key") String key, @Param("value") String value);
    List<Profile> queryNopage2(@Param("key") String key, @Param("value") String value,@Param("key2") String key2, @Param("value2") String value2);

    int insert(@Param("PrjCode") String PrjCode, @Param("Code") String Code,
               @Param("Name") String Name, @Param("IDLine") String IDLine,
               @Param("Order") String Order, @Param("Lat") String Lat, @Param("Lon") String Lon);

    Integer update(@Param("SYSID") int SYSID,@Param("PrjCode") String PrjCode, @Param("Code") String Code,
                   @Param("Name") String Name, @Param("IDLine") String IDLine,
                   @Param("Order") String Order, @Param("Lat") String Lat, @Param("Lon") String Lon
    );

    Integer delete(@Param("SYSID") int SYSID);


    List<Profile> getLine(@Param("PrjCode")String PrjCode);
    List<Profile> getPoint(@Param("PrjCode")String PrjCode,@Param("IDLine")String IDLine);

    List<Profile> getLine_Page(@Param("PrjCode")String PrjCode,@Param("start") int start, @Param("end") int end);
    Integer getLine_Num(@Param("PrjCode")String PrjCode);
    List<Profile> getPoint_Page(@Param("PrjCode")String PrjCode,@Param("IDLine")String IDLine,@Param("start") int start, @Param("end") int end);
    Integer getPoint_Num(@Param("PrjCode")String PrjCode,@Param("IDLine")String IDLine);
}
